package com.koocloud.electroplatemanage.mapper;

import com.koocloud.electroplatemanage.pojo.PersonMonths;
import com.koocloud.electroplatemanage.pojo.PersonWeeks;
import com.koocloud.electroplatemanage.pojo.StatAllResult;
import com.koocloud.electroplatemanage.pojo.StatAllWeekResult;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;

/**
 * @program: electroplatemanage
 * @description: 报表统计Mapper接口
 * @author: xxc
 * @create: 2020-10-13 09:54
 */
@Mapper
public interface StatReportMapper {

    //查询月完成量
    List<StatAllResult> selectAllMonthStatus(String year);

    //查询周完成量
    List<StatAllWeekResult> selectAllWeekStatus(String year);

    //个人按月完成项数
    List<PersonMonths> selectPersonMonthTerms(String year);

    //个人按月完成件数
    List<PersonMonths> selectPersonMonthCounts(String year);

    //个人按月完成件数含税总价
    List<PersonMonths> selectPersonMonthPrices(String year);

    //个人按月完成件数总工时
    List<PersonMonths> selectPersonMonthTimes(String year);

    //个人按周完成项数
    List<PersonWeeks> selectPersonWeekTerms(String year);

    //个人按周完成件数
    List<PersonWeeks> selectPersonWeekCounts(String year);

    //个人按周完成件数含税总价
    List<PersonWeeks> selectPersonWeekPrices(String year);

    //个人按周完成件数总工时
    List<PersonWeeks> selectPersonWeekTimes(String year);
}
